Data: from 2021-09-06 to 2022-09-06. This analysis is to study how different annual members and casual riders used Cyclistic bikes.
1. Overall
The table below shows the summary of trip length statistics (in seconds).
- Annual members rode more trips than casual riders, but the trip length of casual rides are 2.3 times longer than that of annual members.
- Average trip length of
- all members: 1180 seconds (or 19 minutes)
- casual riders: 1754 seconds (or 29 minutes)
- annual members: 770 seconds (or 12 minutes)
| DataType |
TripCount |
TripCountPercent |
Min_Length |
Q1_Length |
Median_Length |
Mean_Length |
Q3_Length |
Max_Length |
| all |
5,748,185 |
100% |
0 |
362 |
640 |
1,180 |
1,154 |
2,442,301 |
| casual |
2,396,331 |
41.7% |
0 |
472 |
830 |
1,754 |
1,524 |
2,442,301 |
| member |
3,351,854 |
58.3% |
0 |
311 |
537 |
770 |
931 |
93,594 |
2. Number of rides
- The number of trips decreased during the winter season from November to February.
- The same pattern were seen for both groups, casual riders and annual members.
3. Trip length
- The trip length outside 1.5 interquartile range (IQR = Q3 - Q1) or longer than 2342 seconds (or approximately 39 minutes) was considered outliers and excluded from the following charts.
- The trip length during winter season from November to February was shorter than that of the other months.
Trip Length by Month

Trip Length by User Type

Trip Length by Month and User Type

4. By day of week
- Averagely, weekends had more rides than weekdays. The trend was opposite during winter months from November to February, when Monday to Thursday had more rides than other days.
- The trip length were longer during weekends, and the trend kept consistent throughout the year.
Average number of rides per day by day of week
All

Nov - Feb

Mar - Oct

Trip Length by day of week


Trip Length by day of week by user type
